﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using HK2009.BusinessFacade;
using HK2009.EntityManage;
using HK2009.Common;
using HK2009.EntityQuery;
namespace HK2009.BusinessFacadeHandler
{
   
    public class JobHandler : IJobHandler
    {
        DataBase db = new DataBase();
        BN_ShippingOrderManage orderManage = new BN_ShippingOrderManage();
        BN_ShippingOrderDtlManage orderDtlManage = new BN_ShippingOrderDtlManage();
        /// <summary>
        /// 根据id获取
        /// </summary>
        /// <param name="pkid"></param>
        /// <returns></returns>
        public BN_ShippingOrderQuery GetShippingOrderByID(int pkid)
        {
            return orderManage.GetBN_ShippingOrderQuery(pkid);
        }

        public DataTable GetShippingOrder(string sqlStr, SqlParameter[] parms)
        {
            return db.RunSqlTab(sqlStr, parms);
        }

        public DataTable GetShippingOrderDtl(string sqlStr, SqlParameter[] parms)
        {
            return db.RunSqlTab(sqlStr, parms);
        }

        public bool ShippingOrderUpdate(string sqlStr, SqlParameter[] parms)
        {
            return db.ExecSqlTransaction(sqlStr, parms);
        }
    }
}
